Using the Consolidated Summary report

The Consolidated Summary report provides transparency into your organization’s operations by displaying a comparison of actual to forecast data that allows you to see trended information of the forecast compared to prior results.

The comparison of actual to forecast is displayed in three primary views: (1) Annual, (2) Quarterly, and (3) Monthly.

Additionally, views can be drilled into for more detail.

The ratios at the bottom of the report add important analytics beyond the pure numbers. For example, Benefits as a % of Salaries may show an anomaly that needs to be reviewed. Such an anomaly may not be apparent from just the numbers alone.

To access the Consolidated Summary report:

  1. In the RF Admin or Rolling Fcsting task pane under Reporting, double-click Consolidated Summary.

  2. In the Refresh Variables dialog, do the following:

    1. For Include Budget?, select Yes to include budget data or No to exclude it.

      NOTE: The Include Budget? option does not display if there are no RF_Forecast records for which RFDType = Budget.

    2. For Select RFPeriod for Forecast, available selections include RFPeriods prior to the current period that have ForecastFinal or DeductionResult records. The default is the most recent of these periods. Click Choose Value and select the desired period.

      NOTE: If there is only one period of forecast data available, the current period is available for selection.

    3. (Optional) If you want to include an RFGroup column from the RFGROUP table, then from the Select RFGroup Column drop-down, select the desired column. If needed, select any additional options that your selection provides (e.g., if you selected Entity, you are presented with the option to select one or more Entities).

    4. From the Select Scenario drop-down, select the desired scenario.

    5. Click OK.

      The report displays data for the selected Scenario, RFPeriod, and RFGroup. The report data is filtered by your RF_Forecast security permissions.

  3. Upon open, the report displays the default view. To change to a different view, in the Main ribbon tab, in the Workbook Options section, click Change View and select the desired view:

  4. To quickly access the Profitability, Utilization, or Labor Utilization sections, in the Main ribbon tab, in the Workbook Options section, click GoTo > Ratios and select the desired section.